package com.wy2.entity;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

import com.wy2.util.PoiHandler;

@Entity
@Table(name="student")
public class Student {

	@Id
	@PoiHandler(excelHeader="学生编号",excelIgnore=true)
	private Integer sid;
	@PoiHandler(excelHeader="网络咨询师编号")
	private String wlid;
	@PoiHandler(excelHeader="学生姓名")
	private String sname;
	@PoiHandler(excelHeader="年龄")
	private Integer sage;
	@PoiHandler(excelHeader="性别")
	private String sex;
	@PoiHandler(excelHeader="手机号码")
	private String stel;
	@PoiHandler(excelHeader="来源渠道")
	private String schannel;
	@PoiHandler(excelHeader="来源关键字")
	private String skeyword;
	@PoiHandler(excelHeader="学历")
	private String sedu;
	@PoiHandler(excelHeader="sqq")
	private String sqq;
	@PoiHandler(excelHeader="微信")
	private String schart;
	@PoiHandler(excelHeader="学生状态")
	private String status;
	@PoiHandler(excelHeader="来源网址")
	private String surl;
	@PoiHandler(excelHeader="网络咨询角色写的备注")
	private String swjremarks;
	@PoiHandler(excelHeader="咨询师id")
	private String zxid;
	@PoiHandler(excelHeader="课程方向")
	private String scourses;
	@PoiHandler(excelHeader="学生情况|打分")
	private String sgrade;
	@PoiHandler(excelHeader="是否有效")
	private String sisvalid;
	@PoiHandler(excelHeader="无效原因")
	private String sreason;
	@PoiHandler(excelHeader="是否首次回访")
	private String sisvisit;
	@PoiHandler(excelHeader="首次回访时间")
	private String svisitime;
	@PoiHandler(excelHeader="是否上门")
	private String sishome;
	@PoiHandler(excelHeader="上门时间")
	private String shometime;
	@PoiHandler(excelHeader="定金金额")
	private String smoney;
	@PoiHandler(excelHeader="定金时间")
	private String smoneytime;
	@PoiHandler(excelHeader="是否已经完成缴费")
	private String sispay;
	@PoiHandler(excelHeader="完成缴费时间")
	private String spaytime;
	@PoiHandler(excelHeader="缴费金额")
	private String spaymoney;
	@PoiHandler(excelHeader="是否退费")
	private String sisrefund;
	@PoiHandler(excelHeader="退费原因")
	private String srefundreason;
	@PoiHandler(excelHeader="退费时间")
	private String srefundtime;
	@PoiHandler(excelHeader="是否已经进班")
	private String sisclass;
	@PoiHandler(excelHeader="进班备注")
	private String sclaremarks;
	@PoiHandler(excelHeader="咨询师对学生备注")
	private String szxramarks;
	@PoiHandler(excelHeader="预留字段")
	private String ext;
	@PoiHandler(excelHeader="咨询师")
	private String zxsname ;
	public Integer getSid() {
		return sid;
	}
	public void setSid(Integer sid) {
		this.sid = sid;
	}
	public String getWlid() {
		return wlid;
	}
	public void setWlid(String wlid) {
		this.wlid = wlid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public Integer getSage() {
		return sage;
	}
	public void setSage(Integer sage) {
		this.sage = sage;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getStel() {
		return stel;
	}
	public void setStel(String stel) {
		this.stel = stel;
	}
	public String getSchannel() {
		return schannel;
	}
	public void setSchannel(String schannel) {
		this.schannel = schannel;
	}
	public String getSkeyword() {
		return skeyword;
	}
	public void setSkeyword(String skeyword) {
		this.skeyword = skeyword;
	}
	public String getSedu() {
		return sedu;
	}
	public void setSedu(String sedu) {
		this.sedu = sedu;
	}
	public String getSqq() {
		return sqq;
	}
	public void setSqq(String sqq) {
		this.sqq = sqq;
	}
	public String getSchart() {
		return schart;
	}
	public void setSchart(String schart) {
		this.schart = schart;
	}
	public String getStatus() {
		return status;
	}
	public void setStatus(String status) {
		this.status = status;
	}
	public String getSurl() {
		return surl;
	}
	public void setSurl(String surl) {
		this.surl = surl;
	}
	public String getSwjremarks() {
		return swjremarks;
	}
	public void setSwjremarks(String swjremarks) {
		this.swjremarks = swjremarks;
	}
	public String getZxid() {
		return zxid;
	}
	public void setZxid(String zxid) {
		this.zxid = zxid;
	}
	public String getScourses() {
		return scourses;
	}
	public void setScourses(String scourses) {
		this.scourses = scourses;
	}
	public String getSgrade() {
		return sgrade;
	}
	public void setSgrade(String sgrade) {
		this.sgrade = sgrade;
	}
	public String getSisvalid() {
		return sisvalid;
	}
	public void setSisvalid(String sisvalid) {
		this.sisvalid = sisvalid;
	}
	public String getSreason() {
		return sreason;
	}
	public void setSreason(String sreason) {
		this.sreason = sreason;
	}
	public String getSisvisit() {
		return sisvisit;
	}
	public void setSisvisit(String sisvisit) {
		this.sisvisit = sisvisit;
	}
	public String getSvisitime() {
		return svisitime;
	}
	public void setSvisitime(String svisitime) {
		this.svisitime = svisitime;
	}
	public String getSishome() {
		return sishome;
	}
	public void setSishome(String sishome) {
		this.sishome = sishome;
	}
	public String getShometime() {
		return shometime;
	}
	public void setShometime(String shometime) {
		this.shometime = shometime;
	}
	public String getSmoney() {
		return smoney;
	}
	public void setSmoney(String smoney) {
		this.smoney = smoney;
	}
	public String getSmoneytime() {
		return smoneytime;
	}
	public void setSmoneytime(String smoneytime) {
		this.smoneytime = smoneytime;
	}
	public String getSispay() {
		return sispay;
	}
	public void setSispay(String sispay) {
		this.sispay = sispay;
	}
	public String getSpaytime() {
		return spaytime;
	}
	public void setSpaytime(String spaytime) {
		this.spaytime = spaytime;
	}
	public String getSpaymoney() {
		return spaymoney;
	}
	public void setSpaymoney(String spaymoney) {
		this.spaymoney = spaymoney;
	}
	public String getSisrefund() {
		return sisrefund;
	}
	public void setSisrefund(String sisrefund) {
		this.sisrefund = sisrefund;
	}
	public String getSrefundreason() {
		return srefundreason;
	}
	public void setSrefundreason(String srefundreason) {
		this.srefundreason = srefundreason;
	}
	public String getSrefundtime() {
		return srefundtime;
	}
	public void setSrefundtime(String srefundtime) {
		this.srefundtime = srefundtime;
	}
	public String getSisclass() {
		return sisclass;
	}
	public void setSisclass(String sisclass) {
		this.sisclass = sisclass;
	}
	public String getSclaremarks() {
		return sclaremarks;
	}
	public void setSclaremarks(String sclaremarks) {
		this.sclaremarks = sclaremarks;
	}
	public String getSzxramarks() {
		return szxramarks;
	}
	public void setSzxramarks(String szxramarks) {
		this.szxramarks = szxramarks;
	}
	public String getExt() {
		return ext;
	}
	public void setExt(String ext) {
		this.ext = ext;
	}
	public String getZxsname() {
		return zxsname;
	}
	public void setZxsname(String zxsname) {
		this.zxsname = zxsname;
	}
	public Student(Integer sid, String wlid, String sname, Integer sage, String sex, String stel, String schannel,
			String skeyword, String sedu, String sqq, String schart, String status, String surl, String swjremarks,
			String zxid, String scourses, String sgrade, String sisvalid, String sreason, String sisvisit,
			String svisitime, String sishome, String shometime, String smoney, String smoneytime, String sispay,
			String spaytime, String spaymoney, String sisrefund, String srefundreason, String srefundtime,
			String sisclass, String sclaremarks, String szxramarks, String ext, String zxsname) {
		super();
		this.sid = sid;
		this.wlid = wlid;
		this.sname = sname;
		this.sage = sage;
		this.sex = sex;
		this.stel = stel;
		this.schannel = schannel;
		this.skeyword = skeyword;
		this.sedu = sedu;
		this.sqq = sqq;
		this.schart = schart;
		this.status = status;
		this.surl = surl;
		this.swjremarks = swjremarks;
		this.zxid = zxid;
		this.scourses = scourses;
		this.sgrade = sgrade;
		this.sisvalid = sisvalid;
		this.sreason = sreason;
		this.sisvisit = sisvisit;
		this.svisitime = svisitime;
		this.sishome = sishome;
		this.shometime = shometime;
		this.smoney = smoney;
		this.smoneytime = smoneytime;
		this.sispay = sispay;
		this.spaytime = spaytime;
		this.spaymoney = spaymoney;
		this.sisrefund = sisrefund;
		this.srefundreason = srefundreason;
		this.srefundtime = srefundtime;
		this.sisclass = sisclass;
		this.sclaremarks = sclaremarks;
		this.szxramarks = szxramarks;
		this.ext = ext;
		this.zxsname = zxsname;
	}
	@Override
	public String toString() {
		return "Student [sid=" + sid + ", wlid=" + wlid + ", sname=" + sname + ", sage=" + sage + ", sex=" + sex
				+ ", stel=" + stel + ", schannel=" + schannel + ", skeyword=" + skeyword + ", sedu=" + sedu + ", sqq="
				+ sqq + ", schart=" + schart + ", status=" + status + ", surl=" + surl + ", swjremarks=" + swjremarks
				+ ", zxid=" + zxid + ", scourses=" + scourses + ", sgrade=" + sgrade + ", sisvalid=" + sisvalid
				+ ", sreason=" + sreason + ", sisvisit=" + sisvisit + ", svisitime=" + svisitime + ", sishome="
				+ sishome + ", shometime=" + shometime + ", smoney=" + smoney + ", smoneytime=" + smoneytime
				+ ", sispay=" + sispay + ", spaytime=" + spaytime + ", spaymoney=" + spaymoney + ", sisrefund="
				+ sisrefund + ", srefundreason=" + srefundreason + ", srefundtime=" + srefundtime + ", sisclass="
				+ sisclass + ", sclaremarks=" + sclaremarks + ", szxramarks=" + szxramarks + ", ext=" + ext
				+ ", zxsname=" + zxsname + "]";
	}
	public Student() {
		super();
	}
	
	
	
}
